This is the Free Evaluation version of the Electronic Teacher Planner/Mark book spreadsheet. The Full paid for version available at: https://www.tes.com/teaching-resource/electronic-teacher-planner-mark-book-12357931 A full paid for TWO WEEK TIMETABLE version is available at: https://www.tes.com/teaching-resource/electronic-teacher-planner-mark-book-two-week-version-12358075 is a full teacher’s planner book enabling you to replace your paper based record book. It enables you to create a colour coded timetable (and will automatically generate a blank timetable with the appropriate number of period per day), a week by week lesson outline planning sheet, a register for each class that records attendance, performance and behavioural information upon each pupil, homework and test scores. The registers will rank the pupils according to assessment criteria, absences and upon test scores. The class analysis page will give detailed information upon the number of lates/tardiness, discipline issues, forgotten books, no homework, incomplete pieces of work and work graded excellent, good, satisfactory and poor. Schemes of work can be created and reports written upon individual students. Print outs of each class can be used at parent consultation evenings and as a record for SLT. Cover lesson instructions can also be created. I have used this spreadsheet in an ongoing developing form for the last 20 years and haven’t used a paper based planner in that time. The spreadsheet does require the use of macros and so they need to be enabled in excel, see the help page in the spreadsheet on how to do this. Please note this spreadsheet will not run on Mac versions of Excel, it will only run on PC versions of , due to incompatibility issues between Microsoft Office on the 2 different platforms.

Save time and effort writing reports. This is the Free restricted evaluation version of the report writing assistant that is available at https://www.tes.com/teaching-resource/report-writer-11740848 The Full version is now in use in over 300 schools in over 20 Countries. The writing assistant allows you to automatically create report comments selected by a click from a series of user modifiable comments. Comments are organised into sections (opening, behavioural, progress, strengths, weaknesses, closing and 3 user defined categories with 18 comments in each section). Comments automatically update to insert the name and to match gender specific pronouns (he/she, his/her etc). Once written the comments can be copied and pasted into your own report packages and a file containing all the reports for your class set can be created. Suitable for all teachers at all key stages through suitable modification of the comments in the comment banks. This is an Excel file which uses macros to run, read the help sheet in the file to enable macros. see a demo of the full version at https://youtu.be/kSKuQOut40U Please note this spreadsheet will not run on Mac versions of Excel, it will only run on PC versions of , due to incompatibility issues between Microsoft Office on the 2 different platforms.

This is a cut down version of the paid for quiz which has all 22 deal or no deal boxes, automatic scoring for 4 teams and 22 questions. This free evaluation version has only 6 boxes and 2 teams and 6 questions. The full paid for version can be found at: https://www.tes.com/teaching-resource/christmas-quiz-2019-premium-deal-or-no-deal-quiz-12222452 Details for the full versio are below A Deal or No Deal type power point quiz that automatically randomizes the values of the 22 boxes and will automatically display the scores for each of up to 4 teams. Divide your group up into up to 4 teams. Each team is assigned a colour. The power point will automatically randomly assign values from 2p to £1500,000 to each box. The 5th slide shows team scores and has a button to jump to the next question. After each question the answer will be displayed with a jump to the Deal or No Deal boxes. The team that got the question can choose a box, clicking on it will display its value, clicking again allows it to be assigned the team colour. click to the next slide will show the team scores which are automatically updated. The jump to the next question box will also automatically change to show the next question and jump to it. If no team is able to give the correct answer to the question then once the answer is shown click on the jump to the Deal or No Deal slide and choose a box and click on it so it goes dark blue and it will then not be counted for any of the 4 teams. When all 22 questions have been answered the show will stop on the score slide, go back to the red boxes slide and click on the reset box to reset all the boxes back to 1-22 and reassigns them with a random value, scores on the score slide will also be reset back to zero and the jump to question box resets back to question 1. The Christmas quiz has 22 questions. You can modify the questions and answers by clicking on and editing their text box contents, but remember DO NOT delete any slides or reorder them, doing so will stop the automation from working. The slide show uses macros; small pieces of code which enables the automation. You MUST enable macros when opening the slide show for the first time, if they are not enabled then the automation will not work. Due to the use of macros the slide show will only work with Microsoft for Windows and Microsoft for Apple version of Power Point and will not work with other slide show presenting software.

An automated COVID-19 Absence tracker. Paid for versions for Primary and Secondary Schools see below. This automated spreadsheet allows you to monitor the impact of coronavirus upon your pupils and staff. Information can be recorded for each year group cohort, recording days absent due to confirmed positive absences, school enforced contact absences & self-isolating absences. All inputs are automated to speed up the entry and display of key data. Including a colour coded calendar displaying the reasons for absences. The calendar can be re-ranked upon numerous criteria with the click of a single button. Individual pupil summaries can be displayed as can the impact of the absences for a set date. This last option aids the calculations necessary for the daily DfE Education Setting Status questions which have to be submitted at 2pm on each term time day. Term dates can again be adjusted with the click of a button for all calendars to suit your establishment. The free evaluation version caters for 13 pupils in a single year group cohort. The full paid for version allows for 250 pupils per year group and for year groups 7-13 & Staff, The spreadsheet requires the use of macros (computer code) to enable the automations. When you first open the spreadsheet, you must enable Macros within Excel. Due to the use of macros this version CAN ONLY be run on Windows Versions of Microsoft Excel. The full paid for version for Secondary Schools is available from: https://www.tes.com/teaching-resource/covid-19-absence-tracking-software-12425525 The full paid for version for Primary Schools is available from: https://www.tes.com/teaching-resource/covid-19-primary-pupil-absence-tracker-12450160

A Deal or No Deal type power point quiz that automatically randomizes the values of the 22 boxes and will automatically display the scores for each of up to 4 teams. got to the link below to try a cut down evaluation version. https://www.tes.com/teaching-resource/christmas-2019-quiz-deal-or-no-deal-free-evaluation-version-12224425 Divide your group up into up to 4 teams. Each team is assigned a colour. The power point will automatically randomly assign values from 2p to £1500,000 to each box. The 5th slide shows team scores and has a button to jump to the next question. After each question the answer will be displayed with a jump to the Deal or No Deal boxes. The team that got the question can choose a box, clicking on it will display its value, clicking again allows it to be assigned the team colour. click to the next slide will show the team scores which are automatically updated. The jump to the next question box will also automatically change to show the next question and jump to it. If no team is able to give the correct answer to the question then once the answer is shown click on the jump to the Deal or No Deal slide and choose a box and click on it so it goes dark blue and it will then not be counted for any of the 4 teams. When all 22 questions have been answered the show will stop on the score slide, go back to the red boxes slide and click on the reset box to reset all the boxes back to 1-22 and reassigns them with a random value, scores on the score slide will also be reset back to zero and the jump to question box resets back to question 1. The Christmas quiz has 22 questions. You can modify the questions and answers by clicking on and editing their text box contents, but remember DO NOT delete any slides or reorder them, doing so will stop the automation from working. The slide show uses macros; small pieces of code which enables the automation. You MUST enable macros when opening the slide show for the first time, if they are not enabled then the automation will not work. Due to the use of macros the slide show will only work with Microsoft for Windows and Microsoft for Apple version of Power Point and will not work with other slide show presenting software.

A tracker to record up to 20 separate test results and provide an analysis of the results. Caters for grades A-E, so is suitable for any A Level subject. Entering grade boundaries for each test the tracker will calculate %'s and show the grades for each student, their ranked position and a summary of all their test results and position overall in their teaching group. Allows up to 40 students to be tracked at a time. Individual student summary page can be produced that can be used when mentoring students or for parent evenings, showing their progress over the year.

Enter up to 22 phrases to automatically generate a hexagon sheet with the terms randomly arranged. Pupils can then cut out the phrases and then sort them into logical groups. Will also allow you to enter 11 different terms and their definitions which are then automatically randomly assigned to the hexagons sheet which can be printed out so that pupils can then cut them out and match up the terms with their definitions. Good for reinforcing vocabulary and the definitions of terms also to make links between terms. Suitable for all subjects and ages

A fully interactive Boggle game, suitable for Key Stage 2 and 3, which is a fun way for pupils to develop their vocabulary and spelling skills. The game has a database of over 300, nine letter words, which are automatically selected randomly by the game. The word’s letters are displayed in a random order in a 3 x 3 grid with the first letter of the 9-letter word displayed as a capital. Pupils have 3 minutes to come up with as many words as possible using the letters, they do not have to use all the letters in their words. A bonus can be given if they find the 9-letter word. Click on the Select new word button to automatically create a new 3x3 grid of letters from a new 9-letter word. Click on the Go button to start the 3-minute timer. A horn will sound at the end of the 3 minutes. To display the 9-letter word click on the reveal the 9-letter word box. The game requires macros to be enabled within Power-point to allow the automated features to work. For this reason it will only run on Power-point for Windows and Power-point for Mac’s, it will not run on other ppt viewers. Further games and educational resources can be found at: https://www.tes.com/teaching-resources/shop/john_leather

This is the Full paid for version of the Electronic Teacher Planner/Mark book spreadsheet. The Free evaluation version is available at: https://www.tes.com/teaching-resource/electronic-teacher-planner-mark-book-free-evaluation-version-11912398 A TWO WEEK Timetable version is available at: https://www.tes.com/teaching-resource/electronic-teacher-planner-mark-book-two-week-version-12358075 This is a full teacher’s planner book enabling you to replace your paper based record book. It enables you to create a colour coded timetable (and will automatically generate a blank timetable with the appropriate number of periods per day), a week by week lesson outline planning sheet, a register for each class that records attendance, performance and behavioural information upon each pupil, homework and test scores. The registers will rank the pupils according to assessment criteria, absences and upon test scores. The class analysis page will give detailed information upon the number of lates/tardiness, discipline issues, forgotten books, no homework, incomplete pieces of work and work graded excellent, good, satisfactory and poor. Schemes of work can be created, and reports written upon individual students. Print outs of each class can be used at parent consultation evenings and as a record for SLT. Cover lesson instructions can also be created. I have used this spreadsheet in an ongoing developing form for the last 20 years and haven’t used a paper-based planner in that time. The spreadsheet uses macros (embedded code) to automate the functions for you so you just have to clickand so they need to be enabled in excel, see the help page in the spreadsheet on how to do this. Please note this spreadsheet will not run on Mac versions of Excel, it will only run on Windows PC versions of, due to incompatibility issues between Microsoft Office on the 2 different platforms.

This is the Full paid for version of the Electronic Teacher Planner/Mark book spreadsheet for teachers with a TWO WEEK TIMETABLE. The Free evaluation version is available at: https://www.tes.com/teaching-resource/electronic-teacher-planner-mark-book-free-evaluation-version-11912398 The paid version for a ONE WEEK TIMETABLE is available from: https://www.tes.com/teaching-resource/electronic-teacher-planner-mark-book-12357931 This is a full teacher’s planner book enabling you to replace your paper based record book. It enables you to create a colour coded timetable (and will automatically generate a blank timetable with the appropriate number of periods per day), a week by week lesson outline planning sheet, a register for each class that records attendance, performance and behavioural information upon each pupil, homework and test scores. The registers will rank the pupils according to assessment criteria, absences and upon test scores. The class analysis page will give detailed information upon the number of lates/tardiness, discipline issues, forgotten books, no homework, incomplete pieces of work and work graded excellent, good, satisfactory and poor. Schemes of work can be created, and reports written upon individual students. Print outs of each class can be used at parent consultation evenings and as a record for SLT. Cover lesson instructions can also be created. I have used this spreadsheet in an ongoing developing form for the last 20 years and haven’t used a paper-based planner in that time. The spreadsheet uses macros (embedded code) to automate the functions so you only have to click a button to add registers and so they need to be enabled in excel, see the help page in the spreadsheet on how to do this. Please note this spreadsheet will not run on Mac versions of Excel, it will only run on Windows PC versions of , due to incompatibility issues between Microsoft Office on the 2 different platforms.

An automated COVID-19 Absence tracker. This automated spreadsheet allows you to monitor the impact of coronavirus upon your pupils and staff. Information can be recorded for each year group cohort, recording days absent due to confirmed positive absences, school enforced contact absences & self-isolating absences. All inputs are automated to speed up the entry and display of key data. Including a colour coded calendar displaying the reasons for absences. The calendar can be re-ranked upon numerous criteria with the click of a single button. Individual pupil summaries can be displayed as can the impact of the absences for a set date. This last option aids the calculations necessary for the daily DfE Education Setting Status questions which have to be submitted at 2pm on each term time day. Term dates can again be adjusted with the click of a button for all calendars to suit your establishment. The free evaluation version caters for 13 pupils in a single year group cohort. The full paid for version allows for 250 pupils per year group and for year groups 7-13 & Staff. The spreadsheet requires the use of macros (computer code) to enable the automations. When you first open the spreadsheet, you must enable Macros within Excel. Due to the use of macros this version CAN ONLY be run on Windows Versions of Microsoft Excel. A free evaluation version is available from: https://www.tes.com/teaching-resource/covid-19-coronavirus-absence-tracking-software-12425518 A Paid for version for Primary Schools is available from: https://www.tes.com/teaching-resource/covid-19-primary-pupil-absence-tracker-12450160

An automated COVID-19 Absence tracker for Primary Schools This automated spreadsheet allows you to monitor the impact of coronavirus upon your pupils and staff. Information can be recorded for each year group cohort, recording days absent due to confirmed positive absences, school enforced contact absences & self-isolating absences. All inputs are automated to speed up the entry and display of key data. Including a colour coded calendar displaying the reasons for absences. The calendar can be re-ranked upon numerous criteria with the click of a single button. Individual pupil summaries can be displayed as can the impact of the absences for a set date. This last option aids the calculations necessary for the daily DfE Education Setting Status questions which have to be submitted at 2pm on each term time day. Term dates can again be adjusted with the click of a button for all calendars to suit your establishment. The free evaluation version caters for 13 pupils in a single year group cohort. The full paid for version allows for 250 pupils per year group and for year groups 1 - 6 & Staff. The spreadsheet requires the use of macros (computer code) to enable the automations. When you first open the spreadsheet, you must enable Macros within Excel. Due to the use of macros this version CAN ONLY be run on Windows Versions of Microsoft Excel. A free evaluation version is available from: https://www.tes.com/teaching-resource/covid-19-coronavirus-absence-tracking-software-12425518 A paid for version for Secondary Schools is available from: https://www.tes.com/teaching-resource/covid-19-absence-tracking-software-12425525

Save time and effort writing reports. An end of year report writer that allows you to quickly create pupil reports simply by clicking on a series of user modifiable comments. Now in use in 400 Schools in over 20 Countries. Comments are organised into 9 sections (opening, behavioural, progress, strengths, weaknesses, closing and 3 user defined categories with 18 comments in each section). Comments automatically update to insert pupil names and to match gender specific pronouns (he/she, his/her etc). Once assembled the comments can be copied and pasted into your own report packages and a file containing all the reports for your class set can be created. Suitable for all teachers at all key stages through suitable modification of the comments in the comment banks. This is Version 2 which scrolls even faster between comment categories. This is an Excel file which uses macros to run, read the help sheet in the file to enable macros. See a demo at https://youtu.be/7rNxxekoUpk Have a look and download the free evaluation version at https://www.tes.com/teaching-resource/report-writer-free-evaluation-version-11751250 Please note this spreadsheet will not run on Mac versions of Excel, it will only run on PC versions of , due to incompatibility issues between Microsoft Office on the 2 different platforms.

Save time and effort writing reports. This report writing assistant allows you to automatically create termly or end of year student report cards from an editable statement bank. Quickly and easily create a report by selecting statements with a click from 18 statements in each of 9 categories (162 statements in all) to build up a complete report comment, all of which will automatically adjust gender pronouns (he/she etc) and insert the students name where appropriate. Comments can also be free typed in the report comment box. All the statements in each category can be customised by the user. A class list with the gender of the students can be inserted and the final report comments can be copied and pasted into any other report package and the overall class comments saved to an xls file for archiving. The spreadsheet uses macros and will require macro access to be enabled, see the help sheet in the spreadsheet for details how to do this. see a demo at https://youtu.be/7rNxxekoUpk Have a look by downloading the free evaluation version at https://www.tes.com/teaching-resource/report-writer-free-evaluation-version-11751250 Please note this spreadsheet will not run on Mac versions of Excel, it will only run on PC versions of , due to incompatibility issues between Microsoft Office on the 2 different platforms.

Save time and effort writing reports. A report writing assistant allowing you to automatically create termly or yearly student report cards from a statement bank. Quickly and easily create a report by selecting statements with a click from 18 statements in each of 9 categories (162 statements in all) to build up a complete report comment, all of which will automatically adjust gender pronouns (he/she etc) and insert the students name where appropriate. Comments can also be free typed in the report comment box. All the statements in each category can be customised by the user. A class list with the gender of the students can be inserted and the final report comments can be copied and pasted into any other report package and the overall class comments saved to an xls file for archiving. The spreadsheet uses macros and will require macro access to be enabled, see the help sheet in the spreadsheet for details how to do this. see a demo at https://youtu.be/7rNxxekoUpk Please note this spreadsheet will not run on Mac versions of Excel, it will only run on PC versions of , due to incompatibility issues between Microsoft Office on the 2 different platforms.

Save time and effort writing report cards. A report card writing assistant allowing you to automatically create termly or yearly student report cards from a statement bank. Quickly and easily create a report by selecting statements with a click from 18 statements in each of 9 categories (162 statements in all) to build up a complete report comment, all of which will automatically adjust gender pronouns (he/she etc) and insert the students name where appropriate. Comments can also be free typed in the report comment box. All the statements in each category can be customised by the user. A class list with the gender of the students can be inserted and the final report comments can be copied and pasted into any other report package and the overall class comments saved to an xls file for archiving. The spreadsheet uses macros and will require macro access to be enabled, see the help sheet in the spreadsheet for details how to do this.   Rd see a demo at https://youtu.be/7rNxxekoUpk Have a look and download the free evaluation version at https://www.tes.com/teaching-resource/report-writer-free-evaluation-version-11751250 Please note this spreadsheet will not run on Mac versions of Excel, it will only run on PC versions of , due to incompatibility issues between Microsoft Office on the 2 different platforms.